package net.huashitong.scheduling.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.sirdc.modules.core.dao.GenericQuery;
import com.sirdc.modules.core.dao.StringDao;

import net.huashitong.scheduling.entity.CorporateTaxation;

@Repository
public class CorporateTaxationDao extends StringDao<CorporateTaxation>{
	
	public List<CorporateTaxation> queryCtList(){
		GenericQuery query = createQuery("obj");
		//query.append(" ORDER BY obj.sysId DESC ");
		return query.listResult();
	}
	
	public List<CorporateTaxation> queryCtListBy(String month,String year){
		GenericQuery query = createQuery("obj");
		query.append(" and obj.month= :month").setParam("month", month);
		query.append(" and obj.year= :year").setParam("year", year);
		return query.listResult();
	}
	
}
